UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+1ZvuRuQk1qcslsQW1NgMMHG5YpyikoNOT9xZH/vUx4='
WHERE
key_id = '336bec2f0051e30cb7a6e30088ec6efe9176c627d2619c17ac9f3260b2dcb6c6'
AND (
token = '+1ZvuRuQk1qcslsQW1NgMMHG5YpyikoNOT9xZH/vUx4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)