UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9a3r+F2Uxz0cbvgh04FB/GRIKTq3HNQcFgCKeufsnNI='
WHERE
key_id = 'a47bb53bfbca8b9612b4872562ddfdcb8c6d42cdc6c9f8207a2c4cf0fdef1fa4'
AND (
token = '9a3r+F2Uxz0cbvgh04FB/GRIKTq3HNQcFgCKeufsnNI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)