UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BqSxysVvwD1AQHUz5GFe7B0YPOlI5SrSMdbYwzWFJuo='
WHERE
key_id = '9bdb549f1ab24b6a73d68002e5a55d53a0684796b4f4f2eea1e3ba056afef0ab'
AND (
token = 'BqSxysVvwD1AQHUz5GFe7B0YPOlI5SrSMdbYwzWFJuo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)