UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xfpTgHFY44BILFsPvqXsLMRDpmEYC2tcKs4nIkp6EHc='
WHERE
key_id = '947bdd288c8688351dd84a83316fdbe1fb6257dd4bdfabd7fcb8476779aa0366'
AND (
token = 'xfpTgHFY44BILFsPvqXsLMRDpmEYC2tcKs4nIkp6EHc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)