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