UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0T6xU7aCzRJ6ZswSRiP1nXfMHBuFM2YZ1VSYtevzxgA='
WHERE
key_id = 'b720fbe6994b6f6b4b56f13e8a460f739870c1b369f8b967f3971f1848af5c34'
AND (
token = '0T6xU7aCzRJ6ZswSRiP1nXfMHBuFM2YZ1VSYtevzxgA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)