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