UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P5esCYz8pv5ggeZAzot2VSMm8DZaDHF3uqI0f4HcahI='
WHERE
key_id = 'c710eeacbf7ca179113b0c3428735eecd6f3b55eb01072d9302e7db5b9659b8c'
AND (
token = 'P5esCYz8pv5ggeZAzot2VSMm8DZaDHF3uqI0f4HcahI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)