UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'idFmeIf2A/yij42pZADW7TtNbfdMGC0PZieEY9iTJis='
WHERE
key_id = '0565ba5fd83b24b67a46546a10fd9f4af52587a7ec7ee456edcdca3d96a54c58'
AND (
token = 'idFmeIf2A/yij42pZADW7TtNbfdMGC0PZieEY9iTJis='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)