UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XO5ZM/Ty4go5Wy64fJKdUU7eK6c80B7k+4OZrXeEeJY='
WHERE
key_id = '524fb24df55628df02c94ea7e6f801f8c46c85c9e30aac5ba09d044c66681b2e'
AND (
token = 'XO5ZM/Ty4go5Wy64fJKdUU7eK6c80B7k+4OZrXeEeJY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)