UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dVUpeFU+hXjvffSupp1eZ/mhDzt3OFnizz+vTxnSYtY='
WHERE
key_id = 'bc9386213023cfa2d04afbadba87215f88a151282ba949b3acb20367ccf5c6d3'
AND (
token = 'dVUpeFU+hXjvffSupp1eZ/mhDzt3OFnizz+vTxnSYtY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)