UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YkSA2CNpGx4CV2fIUDLz/eoYdFGX0BwSHH2+RKeT/7M='
WHERE
key_id = 'ab1b9b71aeca53b3dd49a107a54e6ab22787e2e7ebef179a7198bf1f2c66893f'
AND (
token = 'YkSA2CNpGx4CV2fIUDLz/eoYdFGX0BwSHH2+RKeT/7M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)