UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xRp3doGAeWn1y6UHDED79isvjdUzV/91D+S7A0J4MUU='
WHERE
key_id = '4a040b240a10895f247798ab1b24c61bd1e3960dd1225cf75d4eab5ef6e8e35d'
AND (
token = 'xRp3doGAeWn1y6UHDED79isvjdUzV/91D+S7A0J4MUU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)