UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'idacUBybBNr7zZuiqWpi+6ozp8VxhaXT3ZROdyFPOX8=' 
WHERE 
  key_id = 'e2d70e88eb21a9d8da60b0df7d335a7c3a892b4be1e841f1230216e39880a7c4' 
  AND (
    token = 'idacUBybBNr7zZuiqWpi+6ozp8VxhaXT3ZROdyFPOX8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031