UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DIw22ob0gW1xuMWAUfBFVgy3+Cz22EKKJkg70LuCgFM='
WHERE
key_id = 'a786afde6175ba3ce9d3c75b2b68cd07afc460fb3031a8ec9fa041f769aca3ca'
AND (
token = 'DIw22ob0gW1xuMWAUfBFVgy3+Cz22EKKJkg70LuCgFM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)