UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9aUEav6OvMMQJx9+F1NG0/ZeJxxEzhSUgNKPgz8GV5g='
WHERE
key_id = '4e8b99ad88d0db6745d6a25884546227c95737b4f2edbaf8103d12f19a37002b'
AND (
token = '9aUEav6OvMMQJx9+F1NG0/ZeJxxEzhSUgNKPgz8GV5g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)