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