UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J6RXnUpzPsa8o53T758kHVeIosaj2CYvamu44dt43Zg='
WHERE
key_id = '6fa2f93374dc1e4b2bb2caebfe3ff85b7d0c6af3ab39fb66bdce1322fa96af8d'
AND (
token = 'J6RXnUpzPsa8o53T758kHVeIosaj2CYvamu44dt43Zg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)