UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FH2cDUwB0cCGYPUrCY/I370dV0QBiuYGYtvpLm/n3yU='
WHERE
key_id = 'e31bf871e08e700dc2a9d4e08aa9f7e5e78e772596a2b040613dc85ef26c66af'
AND (
token = 'FH2cDUwB0cCGYPUrCY/I370dV0QBiuYGYtvpLm/n3yU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)