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