UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B7aHBEiHHzppdE/QvP2aRFydhlyTwN0Lbb2ZeODH0gc='
WHERE
key_id = 'ab77bb5386e898a8a8fa9fc9cd416658823cd7d0bfc2b287fcfdf2fed19a7b22'
AND (
token = 'B7aHBEiHHzppdE/QvP2aRFydhlyTwN0Lbb2ZeODH0gc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)