UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DLoGneqG7czv2T20b4f1R6aQ//xCACZCwDssi1822Zw='
WHERE
key_id = '24b46a3ae0372d245a34579d6c91f0ec64822d547d9a02aadba2138651b1f727'
AND (
token = 'DLoGneqG7czv2T20b4f1R6aQ//xCACZCwDssi1822Zw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)