UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8fT9cvXyMi74GiCP2dpEGe0ETWvNxXrE/j10tmW0hYg='
WHERE
key_id = 'b949ae83184b6edd463854c52f39b6eeca7ce6dbe9e59b1228d7e090b0e4362d'
AND (
token = '8fT9cvXyMi74GiCP2dpEGe0ETWvNxXrE/j10tmW0hYg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)