UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BrW2jTqCuw0lt8FZQpJEv8+3SX4r3t9LDRjPy41HWYU='
WHERE
key_id = 'd773668ac01b8ec0e7975d3c8c5cb00227d399db1fd0a53e53701ebebaef7b6c'
AND (
token = 'BrW2jTqCuw0lt8FZQpJEv8+3SX4r3t9LDRjPy41HWYU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)