UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'hZe8jqWxq+53wkV/Kuriaeh8AuHzu9pqBNJk9Tn7Tiw=' 
WHERE 
  key_id = 'a3e3b1e203fa8f029d388f1eec915451ba3c9431d6bacfff13fbfa0c6f0dc565' 
  AND (
    token = 'hZe8jqWxq+53wkV/Kuriaeh8AuHzu9pqBNJk9Tn7Tiw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00081