UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pCG7SdnrtWp4LnlQ1fnxc5RveRaP4b/+E5hvVf/Krv8='
WHERE
key_id = '6e7d304fe45a89c884a3c90b326defe881d24a2fc6dc3de4016c958f34a79912'
AND (
token = 'pCG7SdnrtWp4LnlQ1fnxc5RveRaP4b/+E5hvVf/Krv8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)