UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CJIaUr4QgaXvVHTV9rx3V0Z6enwM5T0La07TIXyOIRQ='
WHERE
key_id = 'b7e18985ff504d896a1157b7e1e11e7b13f8b16c2f0321af2651824fadbf0847'
AND (
token = 'CJIaUr4QgaXvVHTV9rx3V0Z6enwM5T0La07TIXyOIRQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)