UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YP4ZZSJ8BEMCrMi55LCX5WACJWyKCItDkFC+v8B/jjQ='
WHERE
key_id = '627abb2a8c8835de9c472ed74d3ba0768f556838588305d81f85cc8c717bab2b'
AND (
token = 'YP4ZZSJ8BEMCrMi55LCX5WACJWyKCItDkFC+v8B/jjQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)