UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6NQB34PWuArLaqccOUb94Mo1a2ZqTf/+w3JZ2uSIJ3A='
WHERE
key_id = 'f7a737edda1736b3e1b1429a2ff73732d945adf3917ffa275db9f93826d97081'
AND (
token = '6NQB34PWuArLaqccOUb94Mo1a2ZqTf/+w3JZ2uSIJ3A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)