UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7UDrfPyhtoJ9xQCMrTAHDJljxtE6pDPAzItjQL9UxAw='
WHERE
key_id = 'b7161301dbf86cdf936208d70be3983b8658b7a80835defe2ab5c94a6f910f76'
AND (
token = '7UDrfPyhtoJ9xQCMrTAHDJljxtE6pDPAzItjQL9UxAw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)