UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XzH794Rkw4t9S+SAZiPgXozzypu+UmwC55MSaTbbPX8='
WHERE
key_id = 'cabe5ff3e88d91703b1cde5c0fe16fae9b0e1964b84ae19d12d8ae1589008f00'
AND (
token = 'XzH794Rkw4t9S+SAZiPgXozzypu+UmwC55MSaTbbPX8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)