UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'XaR1g2fzFZhT6SneAJCfw0v3akk2srK7hMFdgFi6nRA=' 
WHERE 
  key_id = '23baf580c5a8bc41d1d19ac0dda4fcfb7009e2d73945108365ae4c02433c2c6b' 
  AND (
    token = 'XaR1g2fzFZhT6SneAJCfw0v3akk2srK7hMFdgFi6nRA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027