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