UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'THP3+wnvjCiUL2nqxA7a4C9/MisDvdzqrMc13dzVrgg='
WHERE
key_id = '7770786c93c4797549bfe871ad2c2c1973fe8e8800afed98b65387cfc612c585'
AND (
token = 'THP3+wnvjCiUL2nqxA7a4C9/MisDvdzqrMc13dzVrgg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)