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