UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nAbye/MKwGgMJxEIv+R9pqwqnNtM1JH36rHrY7t7YZw='
WHERE
key_id = 'a013f4d0b81314ae8aea8f6fe55aa96d53843691e27504efdc68acf7f78dd121'
AND (
token = 'nAbye/MKwGgMJxEIv+R9pqwqnNtM1JH36rHrY7t7YZw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)