UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xZzgxfmDvCVNOFN2SKT4n3wieGtXAlVIcw6P3NDJK8o='
WHERE
key_id = '0314a7935603c8904e2cbb9f1d5ccf546fba61b3c2a9e6a110afdacb94b05ff6'
AND (
token = 'xZzgxfmDvCVNOFN2SKT4n3wieGtXAlVIcw6P3NDJK8o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)