UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GuT7sJdQ15uhNpPgaQHu5lFTVSTzB7nGDDN9RWmrhRI='
WHERE
key_id = '06ca0938b4227653312ce1de15a91f0d78ff1993df0b8d9b84ed3ecf771113bc'
AND (
token = 'GuT7sJdQ15uhNpPgaQHu5lFTVSTzB7nGDDN9RWmrhRI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)