UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VYIL0HptqFuyHBm+uxPjN1YFRS/PiIKx19HrRs2z0aM='
WHERE
key_id = 'aabc1a6e9672d5401def10b740dd395b40ccfe2b6f2347fc6a591168f211fe37'
AND (
token = 'VYIL0HptqFuyHBm+uxPjN1YFRS/PiIKx19HrRs2z0aM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)