UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AHaSlfIFklY2QNFMG8M2t2caUWxCOchSAwfpsiOa9T0='
WHERE
key_id = '89dba30a4e2ccfe64b7987538532d8ac2ed5df8d7efcb0adbefb9ec42d4a9507'
AND (
token = 'AHaSlfIFklY2QNFMG8M2t2caUWxCOchSAwfpsiOa9T0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)