UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HFTTChpm4tuwHnUZk1IwbSnUWFff8grAfh6guGFG9co='
WHERE
key_id = 'd8f035a70f19e9b37e3a76a91ffe09a0c15059e070d07df1e4ad060284f07c11'
AND (
token = 'HFTTChpm4tuwHnUZk1IwbSnUWFff8grAfh6guGFG9co='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)