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